home *** CD-ROM | disk | FTP | other *** search
/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d6 / tallyho.arc / WRKSHEET.DOC < prev    next >
Text File  |  1990-09-23  |  9KB  |  129 lines
  1.                REAL ESTATE ANALYSIS WORKSHEET (for REALEST8 program)
  2.                                                                          Page 1
  3.    PART 1
  4.  
  5.   Purchase price___________  MORTGAGE PAYMENT/MO.____________  Points %_________
  6.  
  7.   Down payment_____________  ANNUAL MORTGAGE PAYMENT_________  POINTS___________
  8.  
  9.   Mortgage_________________  No. of years to analyze_________  Closing costs and
  10.  
  11.   Rate________ Life________  Depreciable basis_______________  expenses_________
  12.  
  13.                                              TOTAL INITIAL EXPENSES_____________
  14.   ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
  15.    PART 2
  16.                                Year No.          Year No.          Year No.
  17.      Input factor or     :     _______     :     _______     :     _______     :
  18.                          :                 :                 :                 :
  19.     CALCULATED RESULT    :  Value     PV   :  Value     PV   :  Value     PV   :
  20.   _______________________:________ ________:________ ________:________ ________:
  21.   Average rent/unit/mo.  |        |        |        |        |        |        |
  22.   _______________________|________|________|________|________|________|________|
  23.   No. of rental units    |        |        |        |        |        |        |
  24.   _______________________|________|________|________|________|________|________|
  25.   Vacancy/bad debt %     |        |        |        |        |        |        |
  26.   _______________________|________|________|________|________|________|________|
  27.   Other income           |        |        |        |        |        |        |
  28.   _______________________|________|________|________|________|________|________|
  29.   Real estate taxes      |        |        |        |        |        |        |
  30.   _______________________|________|________|________|________|________|________|
  31.   Insurance              |        |        |        |        |        |        |
  32.   _______________________|________|________|________|________|________|________|
  33.   Management costs       |        |        |        |        |        |        |
  34.   _______________________|________|________|________|________|________|________|
  35.   Maintenance + repairs  |        |        |        |        |        |        |
  36.   _______________________|________|________|________|________|________|________|
  37.   Utilities              |        |        |        |        |        |        |
  38.   _______________________|________|________|________|________|________|________|
  39.   Other expenses         |        |        |        |        |        |        |
  40.   _______________________|________|________|________|________|________|________|
  41.   GROSS OPERATING INCOME |        |        |        |        |        |        |
  42.   _______________________|________|________|________|________|________|________|
  43.   OPERATING EXPENSES     |        |        |        |        |        |        |
  44.   _______________________|________|________|________|________|________|________|
  45.   NET OPERATING INCOME   |        |        |        |        |        |        |
  46.   _______________________|________|________|________|________|________|________|
  47.   MORTGAGE INTEREST      |        |        |        |        |        |        |
  48.   _______________________|________|________|________|________|________|________|
  49.   DEPRECIATION           |        |        |        |        |        |        |
  50.   _______________________|________|________|________|________|________|________|
  51.   Income tax rate        |        |        |        |        |        |        |
  52.   _______________________|________|________|________|________|________|________|
  53.   Appreciation %         |        |        |        |        |        |        |
  54.   _______________________|________|________|________|________|________|________|
  55.   CASH FLOW BEFORE TAX   |        |        |        |        |        |        |
  56.   _______________________|________|________|________|________|________|________|
  57.   TAXABLE INCOME         |        |        |        |        |        |        |
  58.   _______________________|________|________|________|________|________|________|
  59.   TAX LIABILITY          |        |        |        |        |        |        |
  60.   _______________________|________|________|________|________|________|________|
  61.   CASH FLOW AFTER TAX    |        |        |        |        |        |        |
  62.   _______________________|________|________|________|________|________|________|
  63.  
  64.  
  65.  
  66.  
  67.  
  68.                REAL ESTATE ANALYSIS WORKSHEET (for REALEST8 program)
  69.  
  70.    PART 2 (continued)                                                    Page 2
  71.  
  72.                                Year No.          Year No.          Year No.
  73.      Input factor or     :     _______     :     _______     :     _______     :
  74.                          :                 :                 :                 :
  75.     CALCULATED RESULT    :  Value     PV   :  Value     PV   :  Value     PV   :
  76.   _______________________:________ ________:________ ________:________ ________:
  77.   MORTGAGE PRINCIPAL     |        |        |        |        |        |        |
  78.   _______________________|________|________|________|________|________|________|
  79.   CHANGE IN VALUE        |        |        |        |        |        |        |
  80.   _______________________|________|________|________|________|________|________|
  81.   CURRENT VALUE          |        |        |        |        |        |        |
  82.   _______________________|________|________|________|________|________|________|
  83.   CHANGE IN EQUITY       |        |        |        |        |        |        |
  84.   _______________________|________|________|________|________|________|________|
  85.   TOTAL EQUITY           |        |        |        |        |        |        |
  86.   _______________________|________|________|________|________|________|________|
  87.   TOTAL YIELD            |        |        |        |        |        |        |
  88.   _______________________|________|________|________|________|________|________|
  89.                          |        |        |        |        |        |        |
  90.   _______________________|________|________|________|________|________|________|
  91.                          |        |        |        |        |        |        |
  92.   _______________________|________|________|________|________|________|________|
  93.                          |        |        |        |        |        |        |
  94.   _______________________|________|________|________|________|________|________|
  95.                          |        |        |        |        |        |        |
  96.   _______________________|________|________|________|________|________|________|
  97.  
  98.   ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
  99.    PART 3
  100.                                Year No.          Year No.          Year No.
  101.      RATES OF RETURN           _______           _______           _______
  102.      1=Income factor     : Value?          : Value?          : Value?          :
  103.      2=Basis             : or PV?    RATE  : or PV?    RATE  : or PV?    RATE  :
  104.   _______________________:________ ________:________ ________:________ ________:
  105.   1                      |        |        |        |        |        |        |
  106.   _______________________|_......_|        |_......_|        |_......_|        |
  107.   2                      |        |        |        |        |        |        |
  108.   _______________________|________|________|________|________|________|________|
  109.   1                      |        |        |        |        |        |        |
  110.   _______________________|_......_|        |_......_|        |_......_|        |
  111.   2                      |        |        |        |        |        |        |
  112.   _______________________|________|________|________|________|________|________|
  113.   1                      |        |        |        |        |        |        |
  114.   _______________________|_......_|        |_......_|        |_......_|        |
  115.   2                      |        |        |        |        |        |        |
  116.   _______________________|________|________|________|________|________|________|
  117.  
  118.  
  119.      NET PRESENT VALUE   : NET PV   RATIO  : NET PV   RATIO  : NET PV   RATIO  :
  120.   _______________________:________ ________:________ ________:________ ________:
  121.   1                      |        |        |        |        |        |        |
  122.   _______________________|        |        |        |        |        |        |
  123.   2                      |        |        |        |        |        |        |
  124.   _______________________|________|________|________|________|________|________|
  125.   1                      |        |        |        |        |        |        |
  126.   _______________________|        |        |        |        |        |        |
  127.   2                      |        |        |        |        |        |        |
  128.   _______________________|________|________|________|________|________|________|
  129.